Overview

Brought to you by YData

Dataset statistics

Number of variables	31
Number of observations	899164
Missing cells	746666
Missing cells (%)	2.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	212.7 MiB
Average record size in memory	248.0 B

Variable types

Numeric	12
Text	9
DateTime	3
Categorical	6
Boolean	1

Alerts

`ApprovalFY` is highly overall correlated with `RetainedJob` and 1 other fields	High correlation
`LoanNr_ChkDgt` is highly overall correlated with `crisis`	High correlation
`NAICS` is highly overall correlated with `cat_activites`	High correlation
`RetainedJob` is highly overall correlated with `ApprovalFY`	High correlation
`SBA_loan_float` is highly overall correlated with `Term` and 1 other fields	High correlation
`Term` is highly overall correlated with `SBA_loan_float` and 1 other fields	High correlation
`UrbanRural` is highly overall correlated with `ApprovalFY`	High correlation
`bank_loan_float` is highly overall correlated with `SBA_loan_float` and 1 other fields	High correlation
`cat_activites` is highly overall correlated with `NAICS`	High correlation
`crisis` is highly overall correlated with `LoanNr_ChkDgt`	High correlation
`RevLineCr` is highly imbalanced (61.3%)	Imbalance
`BalanceGross` is highly imbalanced (> 99.9%)	Imbalance
`ChgOffDate` has 736465 (81.9%) missing values	Missing
`NoEmp` is highly skewed (γ1 = 80.24824355)	Skewed
`CreateJob` is highly skewed (γ1 = 36.99135473)	Skewed
`RetainedJob` is highly skewed (γ1 = 36.85481184)	Skewed
`LoanNr_ChkDgt` has unique values	Unique
`NAICS` has 201948 (22.5%) zeros	Zeros
`CreateJob` has 629248 (70.0%) zeros	Zeros
`RetainedJob` has 440403 (49.0%) zeros	Zeros
`FranchiseCode` has 208835 (23.2%) zeros	Zeros
`cat_activites` has 201948 (22.5%) zeros	Zeros

Reproduction

Analysis started	2025-02-06 15:21:18.479688
Analysis finished	2025-02-06 15:23:19.989211
Duration	2 minutes and 1.51 second
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

LoanNr_ChkDgt
Real number (ℝ)

High correlation Unique

Distinct	899164
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7726123 × 10⁹

Minimum	1.000014 × 10⁹
Maximum	9.996003 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1.000014 × 10⁹
5-th percentile	1.3484572 × 10⁹
Q1	2.5897575 × 10⁹
median	4.361439 × 10⁹
Q3	6.9046265 × 10⁹
95-th percentile	9.1648039 × 10⁹
Maximum	9.996003 × 10⁹
Range	8.995989 × 10⁹
Interquartile range (IQR)	4.314869 × 10⁹

Descriptive statistics

Standard deviation	2.538175 × 10⁹
Coefficient of variation (CV)	0.53182091
Kurtosis	-1.086499
Mean	4.7726123 × 10⁹
Median Absolute Deviation (MAD)	2.0134 × 10⁹
Skewness	0.3647571
Sum	4.2913612 × 10¹⁵
Variance	6.4423325 × 10¹⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9996003010	1	< 0.1%
1000014003	1	< 0.1%
1000024006	1	< 0.1%
1000034009	1	< 0.1%
1000044001	1	< 0.1%
1000054004	1	< 0.1%
1000084002	1	< 0.1%
1000093009	1	< 0.1%
1000094005	1	< 0.1%
1000104006	1	< 0.1%
Other values (899154)	899154	> 99.9%

Value	Count	Frequency (%)
1000014003	1	< 0.1%
1000024006	1	< 0.1%
1000034009	1	< 0.1%
1000044001	1	< 0.1%
1000054004	1	< 0.1%
1000084002	1	< 0.1%
1000093009	1	< 0.1%
1000094005	1	< 0.1%
1000104006	1	< 0.1%
1000124001	1	< 0.1%

Value	Count	Frequency (%)
9996003010	1	< 0.1%
9995973006	1	< 0.1%
9995613003	1	< 0.1%
9995603000	1	< 0.1%
9995573004	1	< 0.1%
9995563001	1	< 0.1%
9995493004	1	< 0.1%
9995473009	1	< 0.1%
9995453003	1	< 0.1%
9995423005	1	< 0.1%

Name
Text

Distinct	779583
Distinct (%)	86.7%
Missing	14
Missing (%)	< 0.1%
Memory size	6.9 MiB

Length

Max length	30
Median length	23
Mean length	21.775963
Min length	1

Characters and Unicode

Total characters	19579857
Distinct characters	91
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	706468 ?
Unique (%)	78.6%

Sample

1st row	ABC HOBBYCRAFT
2nd row	LANDMARK BAR & GRILLE (THE)
3rd row	WHITLOCK DDS, TODD M.
4th row	BIG BUCKS PAWN & JEWELRY, LLC
5th row	ANASTASIA CONFECTIONS, INC.

Value	Count	Frequency (%)
inc	263379	8.4%
	100280	3.2%
llc	77826	2.5%
and	28959	0.9%
the	28389	0.9%
of	23026	0.7%
dba	20214	0.6%
co	18216	0.6%
a	18114	0.6%
services	17318	0.6%
Other values (226643)	2530176	80.9%

Most occurring characters

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19579857	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19579857	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19579857	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

City
Text

Distinct	32581
Distinct (%)	3.6%
Missing	30
Missing (%)	< 0.1%
Memory size	6.9 MiB

Length

Max length	30
Median length	27
Mean length	9.1030625
Min length	1

Characters and Unicode

Total characters	8184873
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12872 ?
Unique (%)	1.4%

Sample

1st row	EVANSVILLE
2nd row	NEW PARIS
3rd row	BLOOMINGTON
4th row	BROKEN ARROW
5th row	ORLANDO

Value	Count	Frequency (%)
city	23831	2.0%
san	21942	1.8%
new	16075	1.3%
los	13000	1.1%
angeles	12380	1.0%
lake	10729	0.9%
houston	10587	0.9%
beach	10462	0.9%
park	10316	0.9%
york	9724	0.8%
Other values (17695)	1066583	88.5%

Most occurring characters

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8184873	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8184873	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8184873	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

State
Text

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1798328
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	IN
2nd row	IN
3rd row	IN
4th row	OK
5th row	FL

Value	Count	Frequency (%)
ca	130620	14.5%
tx	70463	7.8%
ny	57693	6.4%
fl	41213	4.6%
pa	35170	3.9%
oh	32622	3.6%
il	29669	3.3%
ma	25272	2.8%
mn	24373	2.7%
nj	24036	2.7%
Other values (42)	428033	47.6%

Most occurring characters

Value	Count	Frequency (%)
A	306178	17.0%
C	184958	10.3%
N	181728	10.1%
M	132550	7.4%
T	125075	7.0%
I	119520	6.6%
O	94907	5.3%
L	88820	4.9%
X	70463	3.9%
Y	68255	3.8%
Other values (14)	425874	23.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1798328	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	306178	17.0%
C	184958	10.3%
N	181728	10.1%
M	132550	7.4%
T	125075	7.0%
I	119520	6.6%
O	94907	5.3%
L	88820	4.9%
X	70463	3.9%
Y	68255	3.8%
Other values (14)	425874	23.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1798328	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	306178	17.0%
C	184958	10.3%
N	181728	10.1%
M	132550	7.4%
T	125075	7.0%
I	119520	6.6%
O	94907	5.3%
L	88820	4.9%
X	70463	3.9%
Y	68255	3.8%
Other values (14)	425874	23.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1798328	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	306178	17.0%
C	184958	10.3%
N	181728	10.1%
M	132550	7.4%
T	125075	7.0%
I	119520	6.6%
O	94907	5.3%
L	88820	4.9%
X	70463	3.9%
Y	68255	3.8%
Other values (14)	425874	23.7%

Zip
Real number (ℝ)

Distinct	33611
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53804.391

Minimum	0
Maximum	99999
Zeros	283
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	3838
Q1	27587
median	55410
Q3	83704
95-th percentile	95822
Maximum	99999
Range	99999
Interquartile range (IQR)	56117

Descriptive statistics

Standard deviation	31184.159
Coefficient of variation (CV)	0.5795839
Kurtosis	-1.3359893
Mean	53804.391
Median Absolute Deviation (MAD)	28206
Skewness	-0.16816663
Sum	4.8378972 × 10¹⁰
Variance	9.7245178 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10001	933	0.1%
90015	926	0.1%
93401	806	0.1%
90010	733	0.1%
33166	671	0.1%
90021	666	0.1%
59601	640	0.1%
65804	599	0.1%
3801	581	0.1%
59101	578	0.1%
Other values (33601)	892031	99.2%

Value	Count	Frequency (%)
0	283	< 0.1%
1	24	< 0.1%
2	11	< 0.1%
3	5	< 0.1%
4	5	< 0.1%
5	5	< 0.1%
6	4	< 0.1%
7	6	< 0.1%
8	15	< 0.1%
9	24	< 0.1%

Value	Count	Frequency (%)
99999	209	< 0.1%
99950	3	< 0.1%
99929	15	< 0.1%
99928	1	< 0.1%
99926	1	< 0.1%
99925	4	< 0.1%
99923	1	< 0.1%
99921	13	< 0.1%
99919	2	< 0.1%
99918	1	< 0.1%

Bank
Text

Distinct	5802
Distinct (%)	0.6%
Missing	1559
Missing (%)	0.2%
Memory size	6.9 MiB

Length

Max length	30
Median length	26
Mean length	23.187946
Min length	3

Characters and Unicode

Total characters	20813616
Distinct characters	50
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	923 ?
Unique (%)	0.1%

Sample

1st row	FIFTH THIRD BANK
2nd row	1ST SOURCE BANK
3rd row	GRANT COUNTY STATE BANK
4th row	1ST NATL BK & TR CO OF BROKEN
5th row	FLORIDA BUS. DEVEL CORP

Value	Count	Frequency (%)
bank	651608	18.5%
natl	318240	9.0%
assoc	306768	8.7%
of	142852	4.1%
national	125899	3.6%
america	100686	2.9%
association	84965	2.4%
fargo	63732	1.8%
wells	63650	1.8%
	52264	1.5%
Other values (3602)	1606709	45.7%

Most occurring characters

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20813616	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20813616	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20813616	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

BankState
Text

Distinct	56
Distinct (%)	< 0.1%
Missing	1566
Missing (%)	0.2%
Memory size	6.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1795196
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	OH
2nd row	IN
3rd row	IN
4th row	OK
5th row	FL

Value	Count	Frequency (%)
ca	118116	13.2%
nc	79514	8.9%
il	65908	7.3%
oh	58461	6.5%
sd	51095	5.7%
tx	47790	5.3%
ri	45366	5.1%
ny	39592	4.4%
va	29002	3.2%
de	24537	2.7%
Other values (46)	338217	37.7%

Most occurring characters

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1795196	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1795196	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1795196	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

NAICS
Real number (ℝ)

High correlation Zeros

Distinct	1312
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	398660.95

Minimum	0
Maximum	928120
Zeros	201948
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	235210
median	445310
Q3	561730
95-th percentile	811192
Maximum	928120
Range	928120
Interquartile range (IQR)	326520

Descriptive statistics

Standard deviation	263318.31
Coefficient of variation (CV)	0.66050691
Kurtosis	-1.0476526
Mean	398660.95
Median Absolute Deviation (MAD)	176300
Skewness	-0.26287834
Sum	3.5846157 × 10¹¹
Variance	6.9336534 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	201948	22.5%
722110	27989	3.1%
722211	19448	2.2%
811111	14585	1.6%
621210	14048	1.6%
624410	10111	1.1%
812112	9230	1.0%
561730	8935	1.0%
621310	8733	1.0%
812320	7894	0.9%
Other values (1302)	576243	64.1%

Value	Count	Frequency (%)
0	201948	22.5%
111110	32	< 0.1%
111120	3	< 0.1%
111130	1	< 0.1%
111140	94	< 0.1%
111150	49	< 0.1%
111160	2	< 0.1%
111191	3	< 0.1%
111199	7	< 0.1%
111211	16	< 0.1%

Value	Count	Frequency (%)
928120	32	< 0.1%
928110	4	< 0.1%
927110	1	< 0.1%
926150	10	< 0.1%
926140	6	< 0.1%
926130	3	< 0.1%
926120	5	< 0.1%
926110	6	< 0.1%
925120	1	< 0.1%
925110	3	< 0.1%

ApprovalDate
Date

Distinct	9859
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Minimum	1961-12-07 00:00:00
Maximum	2014-06-25 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ApprovalFY
Real number (ℝ)

High correlation

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.1436

Minimum	1962
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1962
5-th percentile	1991
Q1	1997
median	2002
Q3	2006
95-th percentile	2009
Maximum	2014
Range	52
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.9138459
Coefficient of variation (CV)	0.0029552332
Kurtosis	-0.092531047
Mean	2001.1436
Median Absolute Deviation (MAD)	4
Skewness	-0.58537855
Sum	1.7993562 × 10⁹
Variance	34.973573
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2005	77525	8.6%
2006	76040	8.5%
2007	71876	8.0%
2004	68290	7.6%
2003	58193	6.5%
1995	45758	5.1%
2002	44391	4.9%
1996	40112	4.5%
2008	39540	4.4%
1997	37748	4.2%
Other values (41)	339691	37.8%

Value	Count	Frequency (%)
1962	1	< 0.1%
1965	1	< 0.1%
1966	1	< 0.1%
1967	2	< 0.1%
1968	2	< 0.1%
1969	4	< 0.1%
1970	8	< 0.1%
1971	20	< 0.1%
1972	27	< 0.1%
1973	52	< 0.1%

Value	Count	Frequency (%)
2014	268	< 0.1%
2013	2458	0.3%
2012	5997	0.7%
2011	12608	1.4%
2010	16848	1.9%
2009	19126	2.1%
2008	39540	4.4%
2007	71876	8.0%
2006	76040	8.5%
2005	77525	8.6%

Term
Real number (ℝ)

High correlation

Distinct	412
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	110.77308

Minimum	0
Maximum	569
Zeros	810
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	16
Q1	60
median	84
Q3	120
95-th percentile	300
Maximum	569
Range	569
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	78.857305
Coefficient of variation (CV)	0.7118815
Kurtosis	0.18570424
Mean	110.77308
Median Absolute Deviation (MAD)	33
Skewness	1.1209258
Sum	99603164
Variance	6218.4746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84	230162	25.6%
60	89945	10.0%
240	85982	9.6%
120	77654	8.6%
300	44727	5.0%
180	28164	3.1%
36	19800	2.2%
12	17095	1.9%
48	15621	1.7%
72	9419	1.0%
Other values (402)	280595	31.2%

Value	Count	Frequency (%)
0	810	0.1%
1	1608	0.2%
2	1809	0.2%
3	2112	0.2%
4	2173	0.2%
5	1866	0.2%
6	3054	0.3%
7	1761	0.2%
8	1693	0.2%
9	1875	0.2%

Value	Count	Frequency (%)
569	1	< 0.1%
527	1	< 0.1%
511	1	< 0.1%
505	1	< 0.1%
481	1	< 0.1%
480	1	< 0.1%
461	1	< 0.1%
449	1	< 0.1%
445	1	< 0.1%
443	1	< 0.1%

NoEmp
Real number (ℝ)

Skewed

Distinct	599
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.411353

Minimum	0
Maximum	9999
Zeros	6631
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	10
95-th percentile	40
Maximum	9999
Range	9999
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	74.108196
Coefficient of variation (CV)	6.4942514
Kurtosis	7965.2886
Mean	11.411353
Median Absolute Deviation (MAD)	3
Skewness	80.248244
Sum	10260678
Variance	5492.0248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	154254	17.2%
2	138297	15.4%
3	90674	10.1%
4	73644	8.2%
5	60319	6.7%
6	45759	5.1%
10	31536	3.5%
7	31495	3.5%
8	31361	3.5%
12	20822	2.3%
Other values (589)	221003	24.6%

Value	Count	Frequency (%)
0	6631	0.7%
1	154254	17.2%
2	138297	15.4%
3	90674	10.1%
4	73644	8.2%
5	60319	6.7%
6	45759	5.1%
7	31495	3.5%
8	31361	3.5%
9	18131	2.0%

Value	Count	Frequency (%)
9999	4	< 0.1%
9992	1	< 0.1%
9945	1	< 0.1%
9090	1	< 0.1%
9000	2	< 0.1%
8500	1	< 0.1%
8041	1	< 0.1%
8018	1	< 0.1%
8000	7	< 0.1%
7999	1	< 0.1%

NewExist
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	136
Missing (%)	< 0.1%
Memory size	6.9 MiB

1.0	644869
2.0	253125
0.0	1034

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2697084
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	644869	71.7%
2.0	253125	28.2%
0.0	1034	0.1%
(Missing)	136	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	644869	71.7%
2.0	253125	28.2%
0.0	1034	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2697084	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2697084	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2697084	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

CreateJob
Real number (ℝ)

Skewed Zeros

Distinct	246
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.4303764

Minimum	0
Maximum	8800
Zeros	629248
Zeros (%)	70.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	10
Maximum	8800
Range	8800
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	236.68817
Coefficient of variation (CV)	28.075634
Kurtosis	1369.911
Mean	8.4303764
Median Absolute Deviation (MAD)	0
Skewness	36.991355
Sum	7580291
Variance	56021.288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	629248	70.0%
1	63174	7.0%
2	57831	6.4%
3	28806	3.2%
4	20511	2.3%
5	18691	2.1%
10	11602	1.3%
6	11009	1.2%
8	7378	0.8%
7	6374	0.7%
Other values (236)	44540	5.0%

Value	Count	Frequency (%)
0	629248	70.0%
1	63174	7.0%
2	57831	6.4%
3	28806	3.2%
4	20511	2.3%
5	18691	2.1%
6	11009	1.2%
7	6374	0.7%
8	7378	0.8%
9	3330	0.4%

Value	Count	Frequency (%)
8800	648	0.1%
5621	1	< 0.1%
5199	1	< 0.1%
5085	1	< 0.1%
3500	1	< 0.1%
3100	1	< 0.1%
3000	4	< 0.1%
2515	1	< 0.1%
2140	1	< 0.1%
2020	1	< 0.1%

RetainedJob
Real number (ℝ)

High correlation Skewed Zeros

Distinct	358
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.797257

Minimum	0
Maximum	9500
Zeros	440403
Zeros (%)	49.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	20
Maximum	9500
Range	9500
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	237.1206
Coefficient of variation (CV)	21.961188
Kurtosis	1362.0182
Mean	10.797257
Median Absolute Deviation (MAD)	1
Skewness	36.854812
Sum	9708505
Variance	56226.179
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	440403	49.0%
1	88790	9.9%
2	76851	8.5%
3	49963	5.6%
4	39666	4.4%
5	32627	3.6%
6	23796	2.6%
7	16530	1.8%
8	15698	1.7%
10	15438	1.7%
Other values (348)	99402	11.1%

Value	Count	Frequency (%)
0	440403	49.0%
1	88790	9.9%
2	76851	8.5%
3	49963	5.6%
4	39666	4.4%
5	32627	3.6%
6	23796	2.6%
7	16530	1.8%
8	15698	1.7%
9	8735	1.0%

Value	Count	Frequency (%)
9500	1	< 0.1%
8800	648	0.1%
7250	1	< 0.1%
5000	1	< 0.1%
4441	1	< 0.1%
4000	2	< 0.1%
3900	1	< 0.1%
3860	1	< 0.1%
3225	1	< 0.1%
3200	1	< 0.1%

FranchiseCode
Real number (ℝ)

Zeros

Distinct	2768
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2753.7259

Minimum	0
Maximum	99999
Zeros	208835
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	15805
Maximum	99999
Range	99999
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12758.019
Coefficient of variation (CV)	4.6330025
Kurtosis	24.409524
Mean	2753.7259
Median Absolute Deviation (MAD)	0
Skewness	4.9752152
Sum	2.4760512 × 10⁹
Variance	1.6276705 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	638554	71.0%
0	208835	23.2%
78760	3373	0.4%
68020	1921	0.2%
50564	1034	0.1%
21780	1003	0.1%
25650	715	0.1%
79140	659	0.1%
22470	615	0.1%
17998	606	0.1%
Other values (2758)	41849	4.7%

Value	Count	Frequency (%)
0	208835	23.2%
1	638554	71.0%
3	12	< 0.1%
395	5	< 0.1%
399	3	< 0.1%
400	2	< 0.1%
401	12	< 0.1%
404	1	< 0.1%
407	34	< 0.1%
414	2	< 0.1%

Value	Count	Frequency (%)
99999	1	< 0.1%
92006	4	< 0.1%
92000	9	< 0.1%
91999	11	< 0.1%
91450	2	< 0.1%
91446	1	< 0.1%
91443	2	< 0.1%
91435	1	< 0.1%
91424	1	< 0.1%
91423	2	< 0.1%

UrbanRural
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

1	470654
0	323167
2	105343

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	899164
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring characters

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

RevLineCr
Categorical

Imbalance

Distinct	18
Distinct (%)	< 0.1%
Missing	4528
Missing (%)	0.5%
Memory size	6.9 MiB

N	420288
0	257602
Y	201397
T	15284
1	23
Other values (13)	42

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	894636
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	420288	46.7%
0	257602	28.6%
Y	201397	22.4%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%
(Missing)	4528	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
n	420288	47.0%
0	257602	28.8%
y	201397	22.5%
t	15284	1.7%
1	23	< 0.1%
r	14	< 0.1%
	14	< 0.1%
2	6	< 0.1%
c	2	< 0.1%
3	1	< 0.1%
Other values (5)	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	894636	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	894636	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	894636	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

LowDoc
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	878.2 KiB

False	785060
True	114104

Value	Count	Frequency (%)
False	785060	87.3%
True	114104	12.7%

ChgOffDate
Date

Missing

Distinct	6448
Distinct (%)	4.0%
Missing	736465
Missing (%)	81.9%
Memory size	6.9 MiB

Minimum	1988-10-03 00:00:00
Maximum	2026-10-22 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

DisbursementDate
Date

Distinct	8472
Distinct (%)	0.9%
Missing	2368
Missing (%)	0.3%
Memory size	6.9 MiB

Minimum	1975-01-17 00:00:00
Maximum	2074-12-04 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

DisbursementGross
Text

Distinct	118859
Distinct (%)	13.2%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	15
Median length	14
Mean length	11.537586
Min length	6

Characters and Unicode

Total characters	10374182
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	79785 ?
Unique (%)	8.9%

Sample

1st row	$60,000.00
2nd row	$40,000.00
3rd row	$287,000.00
4th row	$35,000.00
5th row	$229,000.00

Value	Count	Frequency (%)
50,000.00	43787	4.9%
100,000.00	36714	4.1%
25,000.00	27387	3.0%
150,000.00	23373	2.6%
10,000.00	21328	2.4%
35,000.00	14748	1.6%
5,000.00	14193	1.6%
75,000.00	13528	1.5%
20,000.00	13462	1.5%
30,000.00	12696	1.4%
Other values (118849)	677948	75.4%

Most occurring characters

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10374182	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10374182	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10374182	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

BalanceGross
Categorical

Imbalance

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

$0.00	899150
$12,750.00	1
$827,875.00	1
$25,000.00	1
$37,100.00	1
Other values (10)	10

Length

Max length	12
Median length	6
Mean length	6.0000767
Min length	6

Characters and Unicode

Total characters	5395053
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	< 0.1%

Sample

1st row	$0.00
2nd row	$0.00
3rd row	$0.00
4th row	$0.00
5th row	$0.00

Common Values

Value	Count	Frequency (%)
$0.00	899150	> 99.9%
$12,750.00	1	< 0.1%
$827,875.00	1	< 0.1%
$25,000.00	1	< 0.1%
$37,100.00	1	< 0.1%
$43,127.00	1	< 0.1%
$84,617.00	1	< 0.1%
$1,760.00	1	< 0.1%
$115,820.00	1	< 0.1%
$996,262.00	1	< 0.1%
Other values (5)	5	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0.00	899150	> 99.9%
12,750.00	1	< 0.1%
827,875.00	1	< 0.1%
25,000.00	1	< 0.1%
37,100.00	1	< 0.1%
43,127.00	1	< 0.1%
84,617.00	1	< 0.1%
1,760.00	1	< 0.1%
115,820.00	1	< 0.1%
996,262.00	1	< 0.1%
Other values (5)	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5395053	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5395053	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5395053	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

MIS_Status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

P I F	741345
CHGOFF	157819

Length

Max length	6
Median length	5
Mean length	5.1755175
Min length	5

Characters and Unicode

Total characters	4653639
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P I F
2nd row	P I F
3rd row	P I F
4th row	P I F
5th row	P I F

Common Values

Value	Count	Frequency (%)
P I F	741345	82.4%
CHGOFF	157819	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
p	741345	31.1%
i	741345	31.1%
f	741345	31.1%
chgoff	157819	6.6%

Most occurring characters

Value	Count	Frequency (%)
	1482690	31.9%
F	1056983	22.7%
P	741345	15.9%
I	741345	15.9%
C	157819	3.4%
H	157819	3.4%
G	157819	3.4%
O	157819	3.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4653639	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1482690	31.9%
F	1056983	22.7%
P	741345	15.9%
I	741345	15.9%
C	157819	3.4%
H	157819	3.4%
G	157819	3.4%
O	157819	3.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4653639	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1482690	31.9%
F	1056983	22.7%
P	741345	15.9%
I	741345	15.9%
C	157819	3.4%
H	157819	3.4%
G	157819	3.4%
O	157819	3.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4653639	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1482690	31.9%
F	1056983	22.7%
P	741345	15.9%
I	741345	15.9%
C	157819	3.4%
H	157819	3.4%
G	157819	3.4%
O	157819	3.4%

ChgOffPrinGr
Text

Distinct	83165
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	14
Median length	6
Mean length	6.8997235
Min length	6

Characters and Unicode

Total characters	6203983
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	52342 ?
Unique (%)	5.8%

Sample

1st row	$0.00
2nd row	$0.00
3rd row	$0.00
4th row	$0.00
5th row	$0.00

Value	Count	Frequency (%)
0.00	737152	82.0%
50,000.00	2110	0.2%
10,000.00	1865	0.2%
25,000.00	1371	0.2%
35,000.00	1345	0.1%
100,000.00	1028	0.1%
20,000.00	594	0.1%
30,000.00	492	0.1%
15,000.00	467	0.1%
5,000.00	356	< 0.1%
Other values (83155)	152384	16.9%

Most occurring characters

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6203983	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6203983	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6203983	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

GrAppv
Text

Distinct	22128
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	14
Median length	12
Mean length	11.513319
Min length	8

Characters and Unicode

Total characters	10352362
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13651 ?
Unique (%)	1.5%

Sample

1st row	$60,000.00
2nd row	$40,000.00
3rd row	$287,000.00
4th row	$35,000.00
5th row	$229,000.00

Value	Count	Frequency (%)
50,000.00	69394	7.7%
25,000.00	51258	5.7%
100,000.00	50977	5.7%
10,000.00	38366	4.3%
150,000.00	27624	3.1%
20,000.00	23434	2.6%
35,000.00	23181	2.6%
30,000.00	21004	2.3%
5,000.00	19146	2.1%
15,000.00	18472	2.1%
Other values (22118)	556308	61.9%

Most occurring characters

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10352362	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10352362	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10352362	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

SBA_Appv
Text

Distinct	38326
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	14
Median length	11
Mean length	11.308074
Min length	8

Characters and Unicode

Total characters	10167813
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23260 ?
Unique (%)	2.6%

Sample

1st row	$48,000.00
2nd row	$32,000.00
3rd row	$215,250.00
4th row	$28,000.00
5th row	$229,000.00

Value	Count	Frequency (%)
25,000.00	49579	5.5%
12,500.00	40147	4.5%
5,000.00	31135	3.5%
50,000.00	25047	2.8%
10,000.00	17009	1.9%
17,500.00	16141	1.8%
15,000.00	14490	1.6%
7,500.00	12781	1.4%
127,500.00	11946	1.3%
80,000.00	10965	1.2%
Other values (38316)	669924	74.5%

Most occurring characters

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10167813	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10167813	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10167813	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

cat_activites
Real number (ℝ)

High correlation Zeros

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.612263

Minimum	0
Maximum	92
Zeros	201948
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	23
median	44
Q3	56
95-th percentile	81
Maximum	92
Range	92
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	26.284706
Coefficient of variation (CV)	0.66354972
Kurtosis	-1.0572678
Mean	39.612263
Median Absolute Deviation (MAD)	18
Skewness	-0.24819754
Sum	35617921
Variance	690.88577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	201948	22.5%
44	84737	9.4%
81	72618	8.1%
54	68170	7.6%
72	67600	7.5%
23	66646	7.4%
62	55366	6.2%
42	48743	5.4%
45	42514	4.7%
33	38284	4.3%
Other values (15)	152538	17.0%

Value	Count	Frequency (%)
0	201948	22.5%
11	9005	1.0%
21	1851	0.2%
22	663	0.1%
23	66646	7.4%
31	11809	1.3%
32	17936	2.0%
33	38284	4.3%
42	48743	5.4%
44	84737	9.4%

Value	Count	Frequency (%)
92	229	< 0.1%
81	72618	8.1%
72	67600	7.5%
71	14640	1.6%
62	55366	6.2%
61	6425	0.7%
56	32685	3.6%
55	257	< 0.1%
54	68170	7.6%
53	13632	1.5%

SBA_loan_float
Real number (ℝ)

High correlation

Distinct	38326
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	149488.79

Minimum	100
Maximum	5472000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	100
5-th percentile	5000
Q1	21250
median	61250
Q3	175000
95-th percentile	626250
Maximum	5472000
Range	5471900
Interquartile range (IQR)	153750

Descriptive statistics

Standard deviation	228414.56
Coefficient of variation (CV)	1.5279712
Kurtosis	25.325514
Mean	149488.79
Median Absolute Deviation (MAD)	48750
Skewness	3.6752753
Sum	1.3441494 × 10¹¹
Variance	5.2173212 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25000	49579	5.5%
12500	40147	4.5%
5000	31135	3.5%
50000	25047	2.8%
10000	17009	1.9%
17500	16141	1.8%
15000	14490	1.6%
7500	12781	1.4%
127500	11946	1.3%
80000	10965	1.2%
Other values (38316)	669924	74.5%

Value	Count	Frequency (%)
100	2	< 0.1%
150	1	< 0.1%
200	2	< 0.1%
250	33	< 0.1%
350	4	< 0.1%
400	4	< 0.1%
475	1	< 0.1%
500	442	< 0.1%
600	12	< 0.1%
650	2	< 0.1%

Value	Count	Frequency (%)
5472000	1	< 0.1%
5000000	1	< 0.1%
4869000	1	< 0.1%
4582000	1	< 0.1%
4500000	23	< 0.1%
4492530	1	< 0.1%
4410000	1	< 0.1%
4320000	1	< 0.1%
4050000	4	< 0.1%
4000000	13	< 0.1%

bank_loan_float
Real number (ℝ)

High correlation

Distinct	22128
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	192686.98

Minimum	200
Maximum	5472000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	200
5-th percentile	10000
Q1	35000
median	90000
Q3	225000
95-th percentile	750000
Maximum	5472000
Range	5471800
Interquartile range (IQR)	190000

Descriptive statistics

Standard deviation	283263.39
Coefficient of variation (CV)	1.4700702
Kurtosis	21.018882
Mean	192686.98
Median Absolute Deviation (MAD)	65000
Skewness	3.5207901
Sum	1.7325719 × 10¹¹
Variance	8.0238149 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50000	69394	7.7%
25000	51258	5.7%
100000	50977	5.7%
10000	38366	4.3%
150000	27624	3.1%
20000	23434	2.6%
35000	23181	2.6%
30000	21004	2.3%
5000	19146	2.1%
15000	18472	2.1%
Other values (22118)	556308	61.9%

Value	Count	Frequency (%)
200	2	< 0.1%
300	1	< 0.1%
400	2	< 0.1%
500	33	< 0.1%
700	4	< 0.1%
800	4	< 0.1%
950	1	< 0.1%
1000	444	< 0.1%
1200	12	< 0.1%
1300	2	< 0.1%

Value	Count	Frequency (%)
5472000	1	< 0.1%
5000000	40	< 0.1%
4991700	1	< 0.1%
4950000	1	< 0.1%
4908500	1	< 0.1%
4900000	2	< 0.1%
4872000	1	< 0.1%
4869000	1	< 0.1%
4830000	1	< 0.1%
4800000	1	< 0.1%

crisis
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

2	711162
1	188002

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	899164
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	711162	79.1%
1	188002	20.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	711162	79.1%
1	188002	20.9%

Most occurring characters

Value	Count	Frequency (%)
2	711162	79.1%
1	188002	20.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	711162	79.1%
1	188002	20.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	711162	79.1%
1	188002	20.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	711162	79.1%
1	188002	20.9%

Interactions

Correlations

	ApprovalFY	BalanceGross	CreateJob	FranchiseCode	LoanNr_ChkDgt	LowDoc	MIS_Status	NAICS	NewExist	NoEmp	RetainedJob	RevLineCr	SBA_loan_float	Term	UrbanRural	Zip	bank_loan_float	cat_activites	crisis
ApprovalFY	1.000	0.000	0.268	-0.452	-0.278	0.363	0.327	0.447	0.065	-0.226	0.546	0.209	-0.366	-0.297	0.659	-0.038	-0.300	0.440	0.412
BalanceGross	0.000	1.000	0.000	0.005	0.001	0.000	0.000	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.001	0.000	0.001	0.000
CreateJob	0.268	0.000	1.000	-0.054	-0.031	0.010	0.012	0.157	0.009	0.034	0.377	0.011	0.078	0.082	0.025	0.026	0.093	0.156	0.014
FranchiseCode	-0.452	0.005	-0.054	1.000	0.392	0.035	0.022	-0.091	0.099	0.121	-0.263	0.044	0.285	0.196	0.013	0.031	0.259	-0.085	0.017
LoanNr_ChkDgt	-0.278	0.001	-0.031	0.392	1.000	0.240	0.237	-0.050	0.062	0.075	-0.142	0.084	0.169	0.121	0.189	0.031	0.139	-0.047	0.573
LowDoc	0.363	0.000	0.010	0.035	0.240	1.000	0.077	0.147	0.164	0.003	0.010	0.219	0.099	0.171	0.206	0.145	0.118	0.147	0.069
MIS_Status	0.327	0.000	0.012	0.022	0.237	0.077	1.000	0.148	0.022	0.004	0.013	0.145	0.070	0.491	0.210	0.080	0.074	0.148	0.172
NAICS	0.447	0.001	0.157	-0.091	-0.050	0.147	0.148	1.000	0.094	-0.154	0.271	0.124	-0.175	-0.081	0.432	-0.034	-0.147	0.998	0.163
NewExist	0.065	0.000	0.009	0.099	0.062	0.164	0.022	0.094	1.000	0.005	0.002	0.065	0.029	0.088	0.030	0.088	0.036	0.094	0.038
NoEmp	-0.226	0.000	0.034	0.121	0.075	0.003	0.004	-0.154	0.005	1.000	0.124	0.000	0.449	0.200	0.010	0.059	0.455	-0.151	0.004
RetainedJob	0.546	0.000	0.377	-0.263	-0.142	0.010	0.013	0.271	0.002	0.124	1.000	0.010	-0.205	-0.157	0.025	-0.026	-0.138	0.268	0.014
RevLineCr	0.209	0.000	0.011	0.044	0.084	0.219	0.145	0.124	0.065	0.000	0.010	1.000	0.050	0.140	0.348	0.056	0.057	0.124	0.161
SBA_loan_float	-0.366	0.000	0.078	0.285	0.169	0.099	0.070	-0.175	0.029	0.449	-0.205	0.050	1.000	0.589	0.051	0.131	0.986	-0.169	0.016
Term	-0.297	0.000	0.082	0.196	0.121	0.171	0.491	-0.081	0.088	0.200	-0.157	0.140	0.589	1.000	0.207	0.142	0.558	-0.076	0.105
UrbanRural	0.659	0.002	0.025	0.013	0.189	0.206	0.210	0.432	0.030	0.010	0.025	0.348	0.051	0.207	1.000	0.126	0.051	0.432	0.367
Zip	-0.038	0.001	0.026	0.031	0.031	0.145	0.080	-0.034	0.088	0.059	-0.026	0.056	0.131	0.142	0.126	1.000	0.119	-0.033	0.033
bank_loan_float	-0.300	0.000	0.093	0.259	0.139	0.118	0.074	-0.147	0.036	0.455	-0.138	0.057	0.986	0.558	0.051	0.119	1.000	-0.142	0.017
cat_activites	0.440	0.001	0.156	-0.085	-0.047	0.147	0.148	0.998	0.094	-0.151	0.268	0.124	-0.169	-0.076	0.432	-0.033	-0.142	1.000	0.163
crisis	0.412	0.000	0.014	0.017	0.573	0.069	0.172	0.163	0.038	0.004	0.014	0.161	0.016	0.105	0.367	0.033	0.017	0.163	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	LoanNr_ChkDgt	Name	City	State	Zip	Bank	BankState	NAICS	ApprovalDate	ApprovalFY	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	ChgOffDate	DisbursementDate	DisbursementGross	BalanceGross	MIS_Status	ChgOffPrinGr	GrAppv	SBA_Appv	cat_activites	SBA_loan_float	bank_loan_float	crisis
0	1000014003	ABC HOBBYCRAFT	EVANSVILLE	IN	47711	FIFTH THIRD BANK	OH	451120	1997-02-28	1997	84	4	2.0	0	0	1	N	Y	NaN	28-Feb-99	$60,000.00	$0.00	P I F	$0.00	$60,000.00	$48,000.00	45	48000.0	60000.0	2
1	1000024006	LANDMARK BAR & GRILLE (THE)	NEW PARIS	IN	46526	1ST SOURCE BANK	IN	722410	1997-02-28	1997	60	2	2.0	0	0	1	N	Y	NaN	31-May-97	$40,000.00	$0.00	P I F	$0.00	$40,000.00	$32,000.00	72	32000.0	40000.0	2
2	1000034009	WHITLOCK DDS, TODD M.	BLOOMINGTON	IN	47401	GRANT COUNTY STATE BANK	IN	621210	1997-02-28	1997	180	7	1.0	0	0	1	N	N	NaN	31-Dec-97	$287,000.00	$0.00	P I F	$0.00	$287,000.00	$215,250.00	62	215250.0	287000.0	2
3	1000044001	BIG BUCKS PAWN & JEWELRY, LLC	BROKEN ARROW	OK	74012	1ST NATL BK & TR CO OF BROKEN	OK	0	1997-02-28	1997	60	2	1.0	0	0	1	N	Y	NaN	30-Jun-97	$35,000.00	$0.00	P I F	$0.00	$35,000.00	$28,000.00	0	28000.0	35000.0	2
4	1000054004	ANASTASIA CONFECTIONS, INC.	ORLANDO	FL	32801	FLORIDA BUS. DEVEL CORP	FL	0	1997-02-28	1997	240	14	1.0	7	7	1	N	N	NaN	14-May-97	$229,000.00	$0.00	P I F	$0.00	$229,000.00	$229,000.00	0	229000.0	229000.0	2
5	1000084002	B&T SCREW MACHINE COMPANY, INC	PLAINVILLE	CT	6062	TD BANK, NATIONAL ASSOCIATION	DE	332721	1997-02-28	1997	120	19	1.0	0	0	1	N	N	NaN	30-Jun-97	$517,000.00	$0.00	P I F	$0.00	$517,000.00	$387,750.00	33	387750.0	517000.0	2
6	1000093009	MIDDLE ATLANTIC SPORTS CO INC	UNION	NJ	7083	WELLS FARGO BANK NATL ASSOC	SD	0	1980-06-02	1980	45	45	2.0	0	0	0	N	N	24-Jun-91	22-Jul-80	$600,000.00	$0.00	CHGOFF	$208,959.00	$600,000.00	$499,998.00	0	499998.0	600000.0	1
7	1000094005	WEAVER PRODUCTS	SUMMERFIELD	FL	34491	REGIONS BANK	AL	811118	1997-02-28	1997	84	1	2.0	0	0	1	N	Y	NaN	30-Jun-98	$45,000.00	$0.00	P I F	$0.00	$45,000.00	$36,000.00	81	36000.0	45000.0	2
8	1000104006	TURTLE BEACH INN	PORT SAINT JOE	FL	32456	CENTENNIAL BANK	FL	721310	1997-02-28	1997	297	2	2.0	0	0	1	N	N	NaN	31-Jul-97	$305,000.00	$0.00	P I F	$0.00	$305,000.00	$228,750.00	72	228750.0	305000.0	2
9	1000124001	INTEXT BUILDING SYS LLC	GLASTONBURY	CT	6073	WEBSTER BANK NATL ASSOC	CT	0	1997-02-28	1997	84	3	2.0	0	0	1	N	Y	NaN	30-Apr-97	$70,000.00	$0.00	P I F	$0.00	$70,000.00	$56,000.00	0	56000.0	70000.0	2

	LoanNr_ChkDgt	Name	City	State	Zip	Bank	BankState	NAICS	ApprovalDate	ApprovalFY	Term	NoEmp	NewExist	FranchiseCode	RevLineCr	LowDoc	ChgOffDate	DisbursementDate	DisbursementGross	BalanceGross	MIS_Status	ChgOffPrinGr	GrAppv	SBA_Appv	cat_activites	SBA_loan_float	bank_loan_float	crisis
899154	9995423005	LITWIN LIVERY SERVICES, INC.	CAMPBELL	OH	44405	JPMORGAN CHASE BANK NATL ASSOC	IL	0	1997-02-27	1997	60	1	1.0	1	0	N	NaN	30-Sep-97	$10,000.00	$0.00	P I F	$0.00	$10,000.00	$5,000.00	0	5000.0	10000.0	2
899155	9995453003	FUTURE LEADERS CENTER, INC.	SO. OZONE PARK	NY	11420	FLUSHING BANK	NY	624410	1997-02-27	1997	180	2	1.0	1	0	N	NaN	30-Jun-97	$123,000.00	$0.00	P I F	$0.00	$128,000.00	$96,000.00	62	96000.0	128000.0	2
899156	9995473009	FABRICATORS STEEL, INC.	BALTIMORE	MD	21224	BANK OF AMERICA NATL ASSOC	MD	332431	1997-02-27	1997	60	20	1.0	1	0	N	NaN	30-Jun-97	$50,000.00	$0.00	P I F	$0.00	$50,000.00	$25,000.00	33	25000.0	50000.0	2
899157	9995493004	PULLTARPS MFG.	EL CAJON	CA	92020	U.S. BANK NATIONAL ASSOCIATION	CA	314912	1997-02-27	1997	36	40	1.0	1	N	N	NaN	31-Mar-97	$200,000.00	$0.00	P I F	$0.00	$200,000.00	$150,000.00	31	150000.0	200000.0	2
899158	9995563001	SHADES WINDOW TINTING AUTO ALA	IRVING	TX	75062	LOANS FROM OLD CLOSED LENDERS	DC	0	1997-02-27	1997	84	5	2.0	1	N	Y	NaN	30-Jun-97	$79,000.00	$0.00	P I F	$0.00	$79,000.00	$63,200.00	0	63200.0	79000.0	2
899159	9995573004	FABRIC FARMS	UPPER ARLINGTON	OH	43221	JPMORGAN CHASE BANK NATL ASSOC	IL	451120	1997-02-27	1997	60	6	1.0	1	0	N	NaN	30-Sep-97	$70,000.00	$0.00	P I F	$0.00	$70,000.00	$56,000.00	45	56000.0	70000.0	2
899160	9995603000	FABRIC FARMS	COLUMBUS	OH	43221	JPMORGAN CHASE BANK NATL ASSOC	IL	451130	1997-02-27	1997	60	6	1.0	1	Y	N	NaN	31-Oct-97	$85,000.00	$0.00	P I F	$0.00	$85,000.00	$42,500.00	45	42500.0	85000.0	2
899161	9995613003	RADCO MANUFACTURING CO.,INC.	SANTA MARIA	CA	93455	RABOBANK, NATIONAL ASSOCIATION	CA	332321	1997-02-27	1997	108	26	1.0	1	N	N	NaN	30-Sep-97	$300,000.00	$0.00	P I F	$0.00	$300,000.00	$225,000.00	33	225000.0	300000.0	2
899162	9995973006	MARUTAMA HAWAII, INC.	HONOLULU	HI	96830	BANK OF HAWAII	HI	0	1997-02-27	1997	60	6	1.0	1	N	Y	8-Mar-00	31-Mar-97	$75,000.00	$0.00	CHGOFF	$46,383.00	$75,000.00	$60,000.00	0	60000.0	75000.0	2
899163	9996003010	PACIFIC TRADEWINDS FAN & LIGHT	KAILUA	HI	96734	CENTRAL PACIFIC BANK	HI	0	1997-02-27	1997	48	1	2.0	1	N	N	NaN	31-May-97	$30,000.00	$0.00	P I F	$0.00	$30,000.00	$24,000.00	0	24000.0	30000.0	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length